Re: export numeric field right alligned

janssensglb@xxxxxxxxxx wrote:
Don't fill the leading blanks with zero's but with spaces...

Arno R


I'm not sure how I can do that.
If the value of the record is eg. 1.23, I need to fill 6 leading
blanks with spaces. If the value is 1234.56, I need to fill 3 leading
blanks with zeros.
Can I do this using the format function?
Thanks


a = 123.45
? Right(string(10," ") & a,10)
123.45
or
? Right(string(10,space(1)) & a,10)
123.45
.

Relevant Pages

  • Re: export numeric field right alligned
    ... Salad wrote: ... Arno R ... blanks with spaces. ... Can I do this using the format function? ...
    (comp.databases.ms-access)
  • Re: export numeric field right alligned
    ... Don't fill the leading blanks with zero's but with spaces... ... Arno R ... blanks with zeros. ... Can I do this using the format function? ...
    (comp.databases.ms-access)
  • Re: Display Zeros (0) in blank cells
    ... I should point out that both of my suggestions *change* blanks to ... ignore blanks but treat zeros as values. ... It is possible to quickly convert blanks to cells without any ... display 0 when you hit it. ...
    (microsoft.public.excel.programming)
  • Re: Zero Values in chart
    ... Assuming you mean you want empty cells not to be treated as zeros: ... use Tools|Options|Chart and specify how you want blanks ... replace blanks by =NA ... > Is there any way to avoid displaying zero values in a chart. ...
    (microsoft.public.excel.charting)
  • Re: numbers and strings
    ... On 9 Mag, 16:26, "Dr.UgoGagliardelli" ... how can I move a number variable in a string variable changing the ... zeros ahead in blanks? ...
    (comp.sys.ibm.as400.misc)