Hey guys,
this one has been grinding my gears for a while now.
I'm a bloody amateur on Excel VBA. However, this one at least seems like it could be simple to solve.
My main objective is formatting cells to an invoice number with letters and symbols.
Example:
Input = 6
Output = R06-0320
So it supposed to be RXX-MMYY (XX = invoice number)
The VBA code I'm using is:
Range("F6:F101").NumberFormat = "R00" & "-" & Format(Now, "MMYY")
But when I type a number in a cell it uses the number zero in the date as a placeholder.
So if today is MMYY = 0320 and I put 6 as a cell value, then it will show me "R00-0326" instead of "R06-0320"
How do I tell Excel to leave the date's zeros as a fixed number and use the other zeros (in this case "R00") as placeholders?
Sorry if this may sound confusing.
I would appreciate any advice. This has been bugging me for over a week now and google can't help me on this one either.
Thanks!
Bookmarks