ExcelBanter - invoice amounts in 2 columns?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - invoice amounts in 2 columns? (https://www.excelbanter.com/excel-discussion-misc-queries/96271-invoice-amounts-2-columns.html)

KatieM

invoice amounts in 2 columns?

on my paper invoice, it has 2 distinct columns. I can only have a figure like
38.50 (in excel) not 38 50 to show up in the 2 separate columns but
still be still classed as one number in excel so i can do formulas etc! any
ideas?

baxybaxy

invoice amounts in 2 columns?

can't you just add the numbers together in your formulas

38 + (50 / 100) and use that?

--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=556011

All times are GMT +1. The time now is 07:01 PM.