Well Chip, I can't say it is encouraging to hear from an Excel expert saying
it can't be done! So may I ask, if it cannot be done via formatting, is
there another approach I can take?

"Chip Pearson" wrote:

That will change the actual value of the cell, which is probably
not what the poster wants. You can't do what is asked with
formatting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"N Harkawat" wrote in message
...
Go to Edit -- replace
Search for .(decimal)
replace (leave that emplty)



"E2engine" wrote in
message
...
I am trying to format numbers without decimal points! Sounds
easy, but is
not. For instance:

1.72 should appear as 172
14.26 should appear as 1426

I am told the reason the customer needs this format is because
they are
importing into a COBOL system and any separator kills the
process. I have
had no luck with this. Anyone have any ideas?

Thanks.