Re: export numeric field right alligned



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

.

Relevant Pages

  • Re: VLOOKUP WITH ALPHA NUMERIC
    ... "arno" wrote: ... > now that you know that your vanilla fills up fields with blanks and ... > that the size is 6 characters you know what to do in your vlookup: ... > up your match kriteria with blanks like: ...
    (microsoft.public.excel.worksheet.functions)
  • 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
    ... Arno R ... blanks with spaces. ... 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)